CREATE PROCEDURE [KS_ShopItemModify]
  @classid int,
  @title nvarchar(255),
  @titlefontcolor varchar(50),
  @producttype int,
  @barcode nvarchar(150),
  @unit nvarchar(50),
  @weight float,
  @intro nvarchar(255),
  @defaultpic nvarchar(255),
  @bigphoto nvarchar(255),
  @keytags varchar(255),
  @hits int,
  @adddate datetime,
  @attribute varchar(255),
  @priority varchar(100),
  @inputer varchar(100),
  @verify int,
  @templatefile varchar(255),
  @attributecart varchar(255),
  @price money=0,
  @price_member money=0,
  @score int=0,
  @groupprice int =0,
  @ischangebuy int =0,
  @changebuyneedprice money=0,
  @changebuypresentprice money=0,
  @islimitbuy int=0,
  @limitbuytaskid int=0,
  @limitbuyprice money=0,
  @limitbuyamount int=0,
  @taxtf tinyint=0,
  @tax float=0,
  @amount int =0,
  @alarmnum int =0,
  @minordernum int=0,
  @maxordernum int =0,
  @seotitle varchar(255),
  @seokeywords varchar(255),
  @seodescription varchar(255),
  @attachmentcharge int=0,
  @attachmentchargeonce int=0,
  @turnurl varchar(255),
  @isscorechange int=0,
  @changescore int=0,
  @template3gfile varchar(255),
  @showon3g int=0,
  @infoid int=0
 AS
  UPDATE [KS_ProductList]
  Set classid=@classid,
  title=@title,
  titlefontcolor=@titlefontcolor,
  producttype=@producttype,
  barcode=@barcode,
  unit=@unit,
  weight=@weight,
  intro=@intro,
  defaultpic=@defaultpic,
  bigphoto=@bigphoto,
  keytags=@keytags, 
  hits=@hits,
  adddate=@adddate,
  attribute=@attribute,
  priority=@priority,
  inputer=@inputer,
  verify=@verify,
  templatefile=@templatefile,
  attributecart=@attributecart,
  price=@price,
  price_member=@price_member,
  score=@score,
  groupprice=@groupprice,
  ischangebuy=@ischangebuy,
  changebuyneedprice=@changebuyneedprice,
  changebuypresentprice=@changebuypresentprice,
  islimitbuy=@islimitbuy,
  limitbuytaskid=@limitbuytaskid,
  limitbuyprice=@limitbuyprice,
  limitbuyamount=@limitbuyamount,
  taxtf=@taxtf,
  tax=@tax,
  amount=@amount,
  alarmnum=@alarmnum,
  minordernum=@minordernum,
  maxordernum=@maxordernum,
  seotitle=@seotitle,
  seokeywords=@seokeywords,
  seodescription=@seodescription,
  attachmentcharge=@attachmentcharge,
  attachmentchargeOnce=@attachmentchargeonce,
  turnurl=@turnurl,
  isscorechange=@isscorechange,
  changescore=@changescore,
  template3gfile=@template3gfile,
  showon3g=@showon3g
  Where InfoID=@infoid
